use hdp_lbg_supin_zplisting;

insert overwrite table dws_zp_wb_n_flow_action partition(dt='${dateSuffix}',action_type='search',logsource)
select
    url
    ,refer_url
    ,source1
    ,source2
    ,source3
    ,'-' as pid
    ,sid
    ,disp_local1
    ,disp_local2
    ,disp_local3
    ,client_local1
    ,client_local2
    ,client_local3
    ,disp_cate1
    ,disp_cate2
    ,disp_cate3
    ,userid
    ,ukey
    ,cookieid
    ,imei
    ,guestuuid
    ,ip
    ,xforward
    ,useragent
    ,spidertag as spider_tag
    ,os
    ,os_version
    ,app_version
    ,stime
    ,platform
    ,div_id
    ,slot
    ,longitude
    ,latitude
    ,abtestjson as abtest_string
    ,'{}' as cuserportrait
    ,'{}' as entrance_param
    ,'{}' as tag_param
    ,card_type
    ,hasinfo
    ,typehasinfo
    ,'-' as keyword
    ,'-' as filter_item
    ,requesttype
    ,info_id
    ,info_type
    ,info_types
    ,'-' as info_lego_tid
    ,'-' as info_make_up
    ,'-' as info_block
    ,info_params
    ,'-' as tjfrom
    ,pageno as page_no
    ,-999999 as page_pos
    ,search_pos
    ,business_line
    ,map() as disp_params
    ,-999999 as exposure_time
    ,map() as exposure_params
    ,-999999 as info_detail_cnt
    ,array() as info_detail_times
    ,map() as info_detail_params
    ,-999999 as im_open_time
    ,-999999 as first_send_time
    ,'-' as session_id
    ,'-' as bc_type
    ,-999999 as has_ack
    ,-999999 as first_ack_time
    ,-999999 as has_read
    ,-999999 as first_read_time
    ,-999999 as has_reply
    ,-999999 as first_reply_time
    ,-999999 as new_session
    ,map() as im_params
    ,-999999 as delivery_cnt
    ,array() as delivery_times
    ,array() as delivery_resumeids
    ,map() as delivery_params
    ,-999999 as tel_cnt
    ,-999999 as tel_conn_cnt
    ,array() as tel_times
    ,array() as tel_conn_times
    ,map() as tel_params
    ,-999999 as yx_cost
    ,-999999 as yx_cash
    ,map() as yx_params
    ,-999999 as jz_cost
    ,-999999 as jz_cash
    ,map() as jz_params
    ,'search_rec' as logsource
from dwd_zp_wb_n_search_rec
where dt = '${dateSuffix}'